Data Source from SQL Server to Power BI 7
Step 1. Open your SQL Server
SQL Server Connection
Server: hypv8669.hostedbyappliedi.net
Username: ColaberryPowerBIReporting
pw: Colaberry99
Database Name: ColaberryPowerBI_Reporting
Below is a screenshot of creating a server connection with Colaberry Server.
Once you have created the steps above you can then watch the GIF below in order to view your data inside of SQL Server once connected to Colaberry Server.
Step 2. Load data from SQL Server into Power BI Desktop
Step 1. Open Power BI Desktop and on the upper left ribbon, click on get data and choose SQL Server.
Step 2. For the log in credentials of the data source use server name and database name provided below:
Server: hypv8669.hostedbyappliedi.net
Database: ColaberryPowerBI_Reporting
Select import mode then click on OK.
1.
2.
Follow the GIF below.
Note: If you have any errors while you are connecting to the SQL Server follow screenshots below .
Learn more about how to load data into power bi:
https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-sql-tutorial
Data Source from SQL Server to Power BI 7Step 1. Open your SQL Server
SQL Server Connection
Server: hypv8669.hostedbyappliedi.net
Username: ColaberryPowerBIReporting
pw: Colaberry99
Database Name: ColaberryPowerBI_Reporting
Below is a screenshot of creating a server connection with Colaberry Server.
Once you have created the steps above you can then watch the GIF below in order to view your data inside of SQL Server once connected to Colaberry Server.
Step 2. Load data from SQL Server into Power BI Desktop
Step 1. Open Power BI Desktop and on the upper left ribbon, click on get data and choose SQL Server.
Step 2. For the log in credentials of the data source use server name and database name provided below:
Server: hypv8669.hostedbyappliedi.net
Database: ColaberryPowerBI_Reporting
Select import mode then click on OK.
1.
2.
Follow the GIF below.
Note: If you have any errors while you are connecting to the SQL Server follow screenshots below .
Learn more about how to load data into power bi:
https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-sql-tutorial